package com.ccp.dev.core.basic.mybatis.dialect;


import com.ccp.dev.core.basic.mybatis.Dialect;

/**
 * A dialect compatible with the H2 database.
 *
 * @author Thomas Mueller
 */
public class H2Dialect extends Dialect {
    @Override
    public boolean supportsLimit() {
        return true;
    }

    @Override
    public String getLimitString(String sql, int offset, String offsetPlaceholder, int limit, String limitPlaceholder) {
        return new StringBuffer(sql.length() + 40).append(sql).append((offset > 0) ? " limit " + limitPlaceholder + " offset " + offsetPlaceholder : " limit " + limitPlaceholder).toString();
    }

    @Override
    public boolean supportsLimitOffset() {
        return true;
    }
}
